Instalacja poprawek za pomocą Gold Image (out-of-place)


$ORACLE_HOME/bin/oraversion -compositeVersion

sudo runInstaller -deployDBGoldImage -imagePath /tmp/p123456.zip \
-targetHome /u01/app/oracle/product/23.0.0/dbhome_2


export ORACLE_HOME=/u01/app/oracle/product/23.0.0/dbhome_2

cd $ORACLE_HOME/bin

./dbca -silent -moveDatabase -sourceDB db01 -executePrereqs

/u01/app/oracle/product/23.0.0/dbhome_2/bin/dbca \
  -silent -moveDatabase -sourceDB db01


export ORACLE_HOME=$ORACLE_BASE/product/23.0.0/dbhome_2

. ~/.bash_profile

sql / as sysdba

SELECT TO_CHAR(ACTION_TIME, 'YYYY-MM-DD') AS ACTION_TIME, ACTION, STATUS, DESCRIPTION FROM   SYS.DBA_REGISTRY_SQLPATCH  ORDER BY ACTION_TIME;





Instalacja poprawek za pomocą OPatch (in-place)


$ORACLE_HOME/OPatch/opatch version

https://updates.oracle.com/download/6880880.html


unzip p6880880_230000_Linux-x86-64.zip -d /tmp/opatch

rm p6880880_230000_Linux-x86-64.zip

mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_"$(date +"%Y_%m_%d")"

cp -r /tmp/opatch/OPatch $ORACLE_HOME/

rm -rf /tmp/opatch

export PATH=$PATH:$ORACLE_HOME/OPatch

opatch lsinventory

opatch lspatches

cd /tmp/patch

unzip <numer_patcha>_Linux-x86-64.zip

rm <numer_patcha>_Linux-x86-64.zip

cd <numer_patcha>  

opatch prereq CheckConflictAgainstOHWithDetail -ph ./

sql / as sysdba

SHUTDOWN IMMEDIATE

EXIT

lsnrctl stop

opatch apply

tail -f /u01/app/oracle/ [...] /cfgtoollogs/opatch/opatch…….log


sql /nolog

connect / as sysdba

STARTUP

ALTER PLUGGABLE DATABASE ALL OPEN;

cd $ORACLE_HOME/OPatch

./datapatch -sanity_checks

./datapatch -verbose

sql / as sysdba

SELECT TO_CHAR(ACTION_TIME, 'YYYY-MM-DD') AS ACTION_TIME,  ACTION, STATUS, DESCRIPTION FROM   SYS.DBA_REGISTRY_SQLPATCH  ORDER BY ACTION_TIME;

opatch rollback -id <numer_patcha>

sql /nolog

connect / as sysdba

STARTUP

ALTER PLUGGABLE DATABASE ALL OPEN;

cd $ORACLE_HOME/OPatch

./datapatch -sanity_checks

./datapatch -verbose

